/*
{
"状态":1,
"名称":"获取-用户信息(复制权限)",
"作者":"陈泽椿",
"创建时间":"2018-06-30",
"功能":"获取-用户信息(复制权限)",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/
declare @company_key int
set @company_key = '{company_key}'
SELECT user_key,user_name FROM dbo.y_user WHERE company_key=@company_key
and EXISTS(SELECT 1 FROM  y_role_user WHERE user_key=y_user.user_key AND role_key<>7)